create  external table jms_dim.dim_network_abnormal_type_union_dt_hi(
  input_date date comment '查询日期',
 network_code string comment '网点编码',
 network_name string comment '网点名称',
 regional_id int comment '大区ID',
  regional_desc string COMMENT '大区名称',
    area_info_id int COMMENT '片区ID',
    area_info_desc string COMMENT '片区名称',
    provider_id int COMMENT '省份ID',
    provider_desc string COMMENT '省份',
    city_id int COMMENT '城市ID',
    city_desc string COMMENT '城市',
    area_id int COMMENT '区/县ID',
    area_desc string COMMENT '区/县',
    is_shaidan int comment '是否筛单网点(0:否;1:是)',
    is_delay int comment '是否顺延网点(0:否;1:是)',
    is_new_open int comment '是否新开网点(0:否;1:是)',
    is_special_report int comment '是否特殊异常网点(0:否;1:是)',
   create_time timestamp comment '数据落地时间',
   is_delete string comment '是否删除'
 )
 comment '异常报备网点类型'
   stored as parquet
     LOCATION
    '/dw/hive/jms_dim.db/external/dim_network_abnormal_type_union_dt_hi'
 ;